UPDATE C1_OAUTH_CONSUMER SET END_DATE = SYSDATE, DATA_STATE_CODE = '0' WHERE
INSTR(','||:oauthConsumerIds||',', ','||OAUTH_CONSUMER_ID||',') > 0